Application Deployment and Performance

Application Deployment and Performance

• start the course
• Install Qlik deployment framework (QDF)
• use Qlik deployment framework (QDF)
• identify the development life cycle
• use QlikView publisher
• use set analysis
• work with client access licenses
• identify the different client access license types
• work with QlikView architecture
• manage QlikView resource usage
• recognize performance tuning techniques in QlikView
• use test data to test your application
• work with QlikView data storage
• improve the performance of your application
• use direct discovery
• perform load tests with JMeter
• use QlikView scalability
• scale by data and users
• scale applications and application design
• use QlikView to deploy your application

Business Intelligence with QlikView

Business Intelligence with QlikView

• start the course
• describe QlikView and how it is used for business intelligence
• install QlikView
• identify the parts of the QlikView user interface and how it can be customized
• configure QlikView user and document settings
• describe and connect to data sources in QlikView to create visualizations
• consolidate multiple data sources into one QlikView visualization report
• create and configure a Table box to select the columns to display in the QlikView visualization
• create and configure a List box and Multibox to display certain elements in a QlikView visualization
• create and configure an Input Box to enter data into QlikView variables and display their values
• add the Statistics box object to a QlikView document to create summaries of the data
• create other objects to specify elements of a QlikView visualization to display
• view the Current Selections window and add the Current Selection object to a QlikView visualization
• add the Search object and use it to search for information within the QlikView document
• sort and filter data in a QlikView document using various methods
• add, copy, delete, promote, and demote sheets within a QlikView document
• align, adjust, and rearrange items in a QlikView document
• configure sheet properties in a QlikView document
• create and use the Bookmark feature in QlikView
• export data from QlikView to other applications and programs
• use the Quick Chart Wizard to create a chart in a QlikView document
• use the Time Chart Wizard to create a time chart within a QlikView document
• use the Statistics Chart Wizard to create a statistic chart in a QlikView document
• manage chart properties in QlikView
• create a pivot table in a QlikView document
• pivot, filter, and change a pivot table in a QlikView document
• use QlikView to create visualizations of BI data for analysis

Dashboards and Comparative Analysis

Dashboards and Comparative Analysis

• start the course
• create dashboards in QlikView
• utilize the functionality of the dashboard
• use the DAR methodology
• work with alternate and inherited states
• analyze data using comparative analysis
• create a dashboard in QlikView

Data Governance and Metadata Management

Data Governance and Metadata Management

• start the course
• identify ETL best practices
• extract data using QlikView
• transform data using QlikView
• load data using QlikView
• work with a third-party ETL product in QlikView
• work with Qlik Datamarket for QlikView
• utilize the concepts of data governance
• understand how to implement data governance
• work with the data governance dashboard
• manage profiles
• understand metadata
• establish descriptive metadata in field names in QlikView
• work with tags and comments in data fields in QlikView
• extract metadata
• manage metadata
• perform ETL and implement data governance in QlikView

Data Modeling

Data Modeling

• start the course
• identify the different data modeling types and their characteristics
• work with and understand the QlikView script editor
• work with QlikView table viewer
• use joining and linking tables
• recognize when to use concatenation
• identify synthetic keys and synthetic tables
• identify circular references
• optimize QVD Loads
• use mapping statements
• use entity relationship diagrams (ERD)
• use transactional tables
• work with dimensional models
• use dimension tables
• use fact tables
• recognize null values
• understand how |w null values are displayed in QlikView documents
• Work with null values in QlikView
• identify normalizing and denormalizing dimensions
• work with conformed dimensions
• create surrogate keys
• use the 4-step dimensional design process
• demonstrate the best practices used when creating a QlikView data model

Macros and Properties

Macros and Properties

• start the course
• use a trigger on sheet level
• use macros in QlikView
• work with QlikView document properties
• work with QlikView object properties
• use macros and triggers

Scripting and Designing

Scripting and Designing

• start the course
• identify scripting best practices
• create and use scripts in QlikView
• use table files wizard
• use the TRACE statement in your script
• use TOTAL qualifier in QlikView
• identify and use aggregate functions
• identify and use conditional functions
• use operators in QlikView
• design effective visualizations
• use affordances
• identify visualization and analysis
• utilize user-centered design in QlikView
• secure your application
• use section access
• identify access control
• create a hidden script
• identify the different types of security
• use inherited access restrictions
• use QlikView encryption
• use QlikView expressions

Server

Server

• start the course
• install QlikView Server
• identify and work with single and multiple server nodes
• work with different types of QlikView servers
• work with QlikView Server architecture
• use the services and reload engine
• use QlikView logs
• identify and work with tasks, documents, and distribution
• work with platform security to authenticate users
• work with platform security to authorize access to resources
• use QlikView Server